Paul Newcome
Paul Newcome
-
Re: Whats wrong with this nested if and vlookup formula?
You are closing out each IF statement before moving on to the next, but they need to be left open so that it is the "value if false" portion of the IF before. Notice the locations of the cl…1 · -
Re: Formula for status color symbols
You would need to use what is called a "nested IF" formula. The details would depend on exactly what you need / how you expect it to work.1 · -
Re: countifs with beetween dates
You are missing the semi-colon between the range and criteria for the first two range/criteria sets.1 · -
Re: HELP! Formula to Find Matching Value Between two Dates in another sheet
INDEX/COLLECT should work. =INDEX(COLLECT({Column To Pull Over}, {1st Criteria Range}, 1st criteria, {2nd Criteria Range}, 2nd criteria), 1)1 · -
Re: Collect % (column 1) based on a checkbox (column 2) and region (column 3)
INDEX, but you wouldn't use the {Range} inside of the CONTAINS function. You would just use @cell exactly as I have it.1 ·
